SD-Surya-2015-08-19 - 20771 - Spec - Vendor Managed Inventory (Chris by 2016-03-31) #OrderEntry #EDISD

SPECIFICATIONS

20771-Spec-Vendor Managed Inventory

Purpose

Bring in orders from Kohls via EDI for vendor based replenishment.

Admin Info

Purpose	Bring in orders from Kohls via EDI for vendor based replenishment
Requested By	Christine DiVincenzo
Spec Created By	Surya Basa
Spec Created Date	08/24/2015
Spec QA by	Deepak Yasam
Objects	VN_T685B V_T683_XX OCS,V1ZBVM,STAM,E J_3ATVAK_V V_TVLS V_TVLSP /AFS/SD_ALLOC J_3AOSL T184 TVAKZ TVASP TVCPA TVCPL V_TVAK V_TVCPLA UNVOLLST VC_ORDP
Document Status	Resolved

Estimates

Sl.No	Activity	Estimation in Hours
1	Research	120
2	Documentation	16
3	Development/ Config	8
4	Unit test in DEV	32
5	Unit test in QUA	16
6	Other activity
	TOTAL	192

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]
NA

Documents

[Attach any document(s) received for the requirement(s)]
Kohls EDI - 855 Map 7-10-15.pdf

LSMW_NED_VD51.txt

Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.	Change Details	Requested By	Requested On	Notes if any
1	Copy text maintained in customer material info record to customer department ID at item.	Chris	01-21-2016

PCR_VMI-Phase I.docx

Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

Ensure inventory is available and orders are replenished based on the sales information sent by Kohls.

In Scope:

[List the activities to be included in scope]

1. Receive 852 POS data from Kohls
2. Receive “open to buy” email from Kohls buyer (bi-weekly)
3. Load BW data into BW weekly
4. Evaluate need and create spreadsheet of orders by store
5. Send file to ASR for manual entry

Orders need to be allocated
Orders need to be blocked for delivery

6. Merchandising reviews order with Kohls
7. Receive approval from Kohls buyer
8. CS Release orders and add output to order
9. EDI consolidates orders and sends PO to Kohls
10. Delivery drops to warehouse with priority code notifying them it is a high priority delivery. We may be able to use the QR code but look into effort to create a new one.
11. Customer department and description text will be maintained as text in customer material info records - this information should be copied to the Customer Department Text (Z009) at item.

Out of Scope:

[Out of scope activities]

Standard VMI automation process wherein replenishment orders are created and confirmations sent to customer. The process is restricted to sales area 1000/10/00 for Kohls customer.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

1. Create a new order type for VMI manual process with auto-allocation.
2. Create a new delivery block and assign to sales document type.
3. Delivery should be created immediately when delivery block is removed
4. Set up copy controls for delivery, invoice, returns, credit and debit memos.
5. Create a new EDI output type for order acknowledgement.
6. Output should trigger on removal of VMI delivery block.
7. Assign customer material info record table to the access containing customer department text.
8. Create LSMW with transaction VD51 to load customer department text using customer material info record.

Test Plan

[List test scenarios/cases to be executed here]

Test ID	Test Scenario	Expected Results
SD001	VMI Order (ZVMI) with Sufficient Inventory and Delivery block	VMI order should be created with delivery block and output not trigger
SD002	VMI Order (ZVMI) with sufficient inventory and delivery block removed	Delivery should be created and EDI output should trigger
SD003	VMI Order (ZVMI) with Credit block customer and delivery block removed	Delivery should not be created and EDI output shouldn't trigger
SD004	VMI Order (ZVMI) with Credit block customer and delivery block removed , credit released	Delivery should be created and EDI output should trigger
SD005	VMI Order (ZVMI) with hard credit block and with delivery block	VMI Order shouldn't be saved
SD006	VMI Order (ZVMI) with header in-completion and with delivery block	VMI order was saved and delivery not create
SD007	VMI Order (ZVMI) with header in-completion and delivery block removed	Delivery should be created and EDI output should trigger
SD008	VMI Order (ZVMI) without inventory and with delivery block	VMI order should be created with J0
SD009	VMI Order (ZVMI) without inventory and with delivery block removed; post inventory	Delivery should create with confirmed inventory and EDI output should trigger
SD010	VMI Order (ZVMI) with partial inventory and with delivery block	VMI order should create for confirmed items and EDI order output shouldn't trigger
SD011	VMI Order (ZVMI) with partial inventory and delivery block removed	Delivery should should create for confirmed items and EDI order output should trigger
SD012	VMI Order (ZVMI) with Cust Dept text (Z009) and delivery block removed	Customer Dept text with two rows should be copied to the delivery and EDI output should trigger
SD013	Return Order (ZRE) with reference to the invoice	Return order should be created and return credit memo with account postings
SD014	Credit Memo Request Order (ZCR) with reference to invoice	Credit memo should be created with account postings
SD015	Debit Memo Request Order (ZDR) with reference to invoice	Debit memo should be created with account postings

Solution Details

[Provide complete technical details for configuration or programming here]

1. Created a new document type ZVMI - NEC VMI Order under transaction VOV8 with all standard copy controls.
2. Defined new blocking reason ZV and assigned to delivery type.
2. Copy controls for delivery creation set up for item category TAN only, under transaction VTLA.
3. Order type is assigned auto allocation type Z001 under transaction J3AS.
4. Created new output type ZBVM with default dispatch time - 4 and mode - 6 (EDI) and assigned with 009 access under NACE transaction.
5. Assign routine - 002 to the output type in the output determination procedure.
6. Assigned KNMT table to the the customer department text access 907.
7. Created LSMW (Project-VD51) for transaction VD51.
8. Created LSMW (Project-VD52) for transaction VD52 to change/update customer department text.

Issues

[List Issues / Bugs identified in configuration or development]

1. It was noticed that credit blocked orders dropped delivery when the block was removed.

This was identified to be a bug and OSS 0001983317 has been provided as a bug fix.
The issue was resolved with the implementation of the OSS.

2. The sales document was saved and delivery created even though key header fields - Incoterms, PO #, Currency, Payment Terms, Document date, Pricing date were missing.
The fields status in the sales header in-completion procedure (11) was updated with status 4 so that delivery didn't create if any one of the fields was missing.